pandas dataframe ranking by values within another column without using a Python FOR loop